Moves in Unfunded Liabilities from 2020-2021
| Dataset | year | TotalOPEB | TotalNPL |
|---|---|---|---|
| City | 2020 | $156,522,239,133 | $178,384,996,141 |
| City | 2021 | $165,964,671,391 | $141,260,147,751 |
| City | 2022 | $130,905,745,444 | $146,684,931,141 |
| County | 2020 | $88,139,766,353 | $114,549,691,913 |
| County | 2021 | $92,114,983,017 | $111,537,178,855 |
| County | 2022 | $81,544,557,919 | $77,814,734,484 |
| SD | 2020 | $52,290,428,798 | $78,463,359,078 |
| SD | 2021 | $55,873,428,067 | $87,451,369,176 |
| SD | 2022 | $52,705,920,347 | $51,649,985,324 |
| State | 2020 | $524,909,940,837 | $684,637,601,415 |
| State | 2021 | $574,807,219,450 | $743,184,295,659 |
| State | 2022 | $528,409,889,023 | $520,513,990,453 |
| Entity | NPL Change | NPL Percent Change | Net OPEB Change | OPEB Percent Change |
|---|---|---|---|---|
| State | -$164,123,610,962 | -24.0% | $3,499,948,186 | 0.67% |
| SD | -$26,813,373,754 | -34.2% | $415,491,549 | 0.79% |
| City | -$31,700,065,000 | -17.8% | -$25,616,493,689 | -16.37% |
| County | -$36,734,957,429 | -32.1% | -$6,595,208,434 | -7.48% |
Moves in Unfunded Liabiities from 2020-2021
## `geom_smooth()` using formula = 'y ~ x'
## Warning: Removed 2 rows containing non-finite values (`stat_smooth()`).
## Warning: Removed 2 rows containing non-finite values (`stat_cor()`).
## Warning: Removed 2 rows containing missing values (`geom_point()`).
States: Correlation Between % Difference in NPL Population
## `geom_smooth()` using formula = 'y ~ x'
## Warning: Removed 2 rows containing non-finite values (`stat_smooth()`).
## Warning: Removed 2 rows containing non-finite values (`stat_cor()`).
## Warning: Removed 2 rows containing missing values (`geom_point()`).
Cities: Correlation Between % Difference in NPL Population
## `geom_smooth()` using formula = 'y ~ x'
## Warning: Removed 5 rows containing non-finite values (`stat_smooth()`).
## Warning: Removed 5 rows containing non-finite values (`stat_cor()`).
## Warning: Removed 3 rows containing missing values (`geom_point()`).
Counties: Correlation Between % Difference in NPL Population
## `geom_smooth()` using formula = 'y ~ x'
## Warning: Removed 10 rows containing non-finite values (`stat_smooth()`).
## Warning: Removed 10 rows containing non-finite values (`stat_cor()`).
## Warning: Removed 10 rows containing missing values (`geom_point()`).
School Districts: Correlation Between % Difference in NPL Population
Total Unfunded Liabilities 2020-2022 - Cities divided by Population Quartiles
| Quartile | Min | Max |
|---|---|---|
| 1 | 208,640 | 259,520 |
| 2 | 263,914 | 383,998 |
| 3 | 384,661 | 631,539 |
| 4 | 639,115 | 8,804,194 |
| Year | Pop Quartile | Total NPL | % Change from Previous Year | $ Change from Previous Year |
|---|---|---|---|---|
| 2021 | 1 | $5,228,004,831 | -3% | -$137,372,891 |
| 2022 | 1 | $3,224,089,824 | -38% | -$2,003,915,007 |
| 2021 | 2 | $9,216,231,780 | -14% | -$1,553,009,578 |
| 2022 | 2 | $6,740,056,661 | -27% | -$2,476,175,119 |
| 2021 | 3 | $18,077,273,298 | 0% | -$7,913,508 |
| 2022 | 3 | $13,913,327,591 | -23% | -$4,163,945,707 |
| 2021 | 4 | $108,738,637,842 | -25% | -$35,426,552,413 |
| 2022 | 4 | $122,807,457,065 | 13% | $14,068,819,223 |
| Entity | Year | Net OPEB Change | OPEB Percent Change |
|---|---|---|---|
| State | 2022 | $3,499,948,186 | 0.67% |
| SD | 2022 | $415,491,549 | 0.79% |
| City | 2022 | -$25,616,493,689 | -16.37% |
| County | 2022 | -$6,595,208,434 | -7.48% |
| Year | Net OPEB Change | OPEB Percent Change |
|---|---|---|
| 2020 | $3,499,948,186 | 1% |
| 2021 | $3,499,948,186 | 1% |
| 2022 | $3,499,948,186 | 1% |
| 2020 | $684,637,601,415.00 | NA |
| 2021 | $743,184,295,659.00 | 8.55% |
| 2022 | $520,513,990,453.00 | -29.96% |
| State | Net Pension Liability | Per Capita |
|---|---|---|
| Illinois | $139,846,000,000 | $10,914.77 |
| New Jersey | $75,075,280,124 | $8,082.14 |
| California | $54,169,128,000 | $1,370.04 |
| Connecticut | $36,132,877,000 | $10,020.37 |
| Massachusetts | $34,806,645,000 | $4,951.19 |
| Texas | $30,883,865,000 | $1,059.65 |
| Kentucky | $25,034,578,000 | $5,555.96 |
| Maryland | $13,366,859,000 | $2,163.90 |
| Pennsylvania | $12,550,399,000 | $965.22 |
| Indiana | $9,781,677,000 | $1,441.52 |
| State | Per Capita NPL | Total NPL |
|---|---|---|
| Illinois | $10,914.77 | $139,846,000,000 |
| Connecticut | $10,020.37 | $36,132,877,000 |
| New Jersey | $8,082.14 | $75,075,280,124 |
| Kentucky | $5,555.96 | $25,034,578,000 |
| Massachusetts | $4,951.19 | $34,806,645,000 |
| Hawaii | $4,345.08 | $6,323,283,000 |
| Vermont | $3,906.27 | $2,512,066,064 |
| Alaska | $3,253.06 | $2,385,726,000 |
| Rhode Island | $2,585.82 | $2,837,608,000 |
| New Mexico | $2,373.82 | $5,026,620,000 |
| 2020 | $178,384,996,141.00 | NA |
| 2021 | $141,260,147,751.00 | -20.81% |
| 2022 | $146,684,931,141.00 | 3.84% |
| City | State | Net Pension Liability | Per Capita |
|---|---|---|---|
| new york | NY | $42,349,466,000 | $4,810.15 |
| chicago | IL | $35,436,606,000 | $12,903.16 |
| philadelphia | PA | $5,386,419,000 | $3,358.54 |
| phoenix | AZ | $4,643,155,000 | $2,887.19 |
| los angeles | CA | $4,363,649,000 | $1,119.24 |
| portland | OR | $4,275,718,773 | $6,552.64 |
| dallas | TX | $4,029,247,000 | $3,089.16 |
| jacksonville | FL | $2,905,810,000 | $3,059.98 |
| san jose | CA | $2,342,879,000 | $2,312.31 |
| houston | TX | $2,322,472,000 | $1,009.08 |
| City | State | Per Capita NPL | Total NPL |
|---|---|---|---|
| chicago | IL | $12,903.16 | $35,436,606,000 |
| portland | OR | $6,552.64 | $4,275,718,773 |
| new york | NY | $4,810.15 | $42,349,466,000 |
| philadelphia | PA | $3,358.54 | $5,386,419,000 |
| dallas | TX | $3,089.16 | $4,029,247,000 |
| cincinnati | OH | $3,086.75 | $955,536,000 |
| jacksonville | FL | $3,059.98 | $2,905,810,000 |
| pittsburgh | PA | $3,050.90 | $924,293,454 |
| miami | FL | $2,942.66 | $1,301,418,710 |
| phoenix | AZ | $2,887.19 | $4,643,155,000 |
| 2020 | $114,549,691,913.00 | NA |
| 2021 | $111,537,178,855.00 | -2.63% |
| 2022 | $77,814,734,484.00 | -30.23% |
| County | State | Net Pension Liability | Per Capita |
|---|---|---|---|
| cook county | IL | $10,837,262,892 | $2,054.25 |
| los angeles county | CA | $7,030,463,000 | $702.06 |
| philadelphia | PA | $5,386,419,000 | $3,358.54 |
| miami-dade county | FL | $3,979,267,000 | $1,472.84 |
| santa clara county | CA | $2,989,893,000 | $1,544.15 |
| jacksonville | FL | $2,905,810,000 | $2,918.77 |
| city and county of honolulu | HI | $2,270,106,000 | $2,233.24 |
| san diego county | CA | $2,246,673,000 | $681.09 |
| orange county | CA | $2,048,680,000 | $642.83 |
| prince georges county | MD | $2,011,969,036 | $2,080.21 |
| County | State | Per Capita | Total NPL |
|---|---|---|---|
| philadelphia | PA | $3,358.54 | $5,386,419,000 |
| jacksonville | FL | $2,918.77 | $2,905,810,000 |
| city and county of honolulu | HI | $2,233.24 | $2,270,106,000 |
| prince georges county | MD | $2,080.21 | $2,011,969,036 |
| cook county | IL | $2,054.25 | $10,837,262,892 |
| denver county | CO | $2,032.63 | $1,454,425,000 |
| baltimore county | MD | $1,863.20 | $1,592,201,000 |
| santa clara county | CA | $1,544.15 | $2,989,893,000 |
| kern county | CA | $1,541.70 | $1,401,786,000 |
| dekalb county | GA | $1,531.02 | $1,170,291,000 |
| 2020 | $78,463,359,078.00 | NA |
| 2021 | $87,451,369,176.00 | 11.46% |
| 2022 | $51,649,985,324.00 | -40.94% |
| County | State | Net Pension Liability | Per Student |
|---|---|---|---|
| Chicago Board of Education | IL | $14,727,410,000 | $42,382.99 |
| Los Angeles Unified School District | CA | $4,311,675,000 | $8,922.54 |
| School District of Philadelphia | PA | $3,253,100,000 | $24,905.64 |
| Clark County School District | NV | $2,167,406,738 | $6,588.04 |
| Fairfax County Public Schools | VA | $2,163,904,859 | $11,456.08 |
| Albuquerque Municipal School District No. 12 | NM | $1,208,673,186 | $13,686.40 |
| Jefferson County School District No R-1 | CO | $1,032,420,784 | $12,279.32 |
| The School Board of Miami-Dade County | FL | $979,938,000 | $2,821.53 |
| The School District of Greenville County | SC | $860,615,385 | $11,133.16 |
| Cherry Creek School District No 5 | CO | $845,137,624 | $15,030.55 |
| County | State | Per Student Net Pension Liability | Total NPL |
|---|---|---|---|
| Chicago Board of Education | IL | $42,382.99 | $14,727,410,000 |
| School District of Philadelphia | PA | $24,905.64 | $3,253,100,000 |
| Cherry Creek School District No 5 | CO | $15,030.55 | $845,137,624 |
| Albuquerque Municipal School District No. 12 | NM | $13,686.40 | $1,208,673,186 |
| Omaha City School District 1 | NE | $13,268.72 | $709,651,000 |
| Jefferson County School District No R-1 | CO | $12,279.32 | $1,032,420,784 |
| Charleston County School District | SC | $11,848.11 | $595,948,185 |
| Boston City School | MA | $11,769.60 | $594,129,250 |
| Fairfax County Public Schools | VA | $11,456.08 | $2,163,904,859 |
| The School District of Greenville County | SC | $11,133.16 | $860,615,385 |